<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html";>
<meta name="keywords" content="DeZign for Databases - HTML Report">
<meta name="author" content="Datanamic - www.datanamic.com">
<title>DeZign for Databases V4 - HTML Report</title>
<link rel="stylesheet" type="text/css" media="screen,print" href="dezign.css" title="report">
</head>
<body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10">
<div class="top">Logical model</div>
<ul id="menu">
<li><a href="index.html">Project details</a></li>
<li><a href="erdiagram.html">ER diagram</a></li>
<li><a href="entl.html">Entities</a></li>
<li><a href="attrl.html">Attributes</a></li>
<li><a href="rell.html">Relationships</a></li>
<li><a href="doml.html">Domains</a></li>
<li><a href="viewl.html">Views</a></li>
<li><a href="procl.html">Procedures</a></li>
</ul>
<div class="row">
<div class="tab"><a href="viewl.html">List of views</a></div>
<div class="activetab">View details</div>
</div>
<table width=90% border=0 cellSpacing=0 cellPadding=0 class="chapter">
<tr>
<td class="left" valign=top>
<ul id="objectbrowser">
<li><a href="#ContactsFullScreenView">ContactsFullScreenView</a></li>
</ul>
</td>
<td class="right" valign=top>
<A NAME="ContactsFullScreenView"></A>
<div class="objectname">View: ContactsFullScreenView</div>
<div class="details">View details:</div>
<table width="100%" border=0 class="detailstable">
<tr><td width=20% class="fieldname">Description</td><td class="fielddata"></td></tr>
<tr><td class="fieldname">Code</td><td class="fielddata">select `ravebizv4`.`contacts`.`contacts_id` AS `contacts_id`,
       `ravebizv4`.`contacts`.`first_name_str` AS `first_name_str`,
       `ravebizv4`.`contacts`.`nick_name_str` AS `nick_name_str`,
       `ravebizv4`.`contacts`.`last_name_str` AS `last_name_str`,
       `ravebizv4`.`contacts`.`company_str` AS `company_str`,
       `ravebizv4`.`contacts`.`ZIP_code` AS `ZIP_code`,
       `ravebizv4`.`zip`.`City` AS `City`,
       `ravebizv4`.`zip`.`County` AS `County`,
       `ravebizv4`.`zip`.`State` AS `State`,
       `ravebizv4`.`contacts`.`email_str` AS `email_str`,
       `ravebizv4`.`contacts`.`referral_method_emn` AS `referral_method_emn`,
       `ravebizv4`.`contacts`.`login_name_str` AS `login_name_str`,
       `ravebizv4`.`contacts`.`login_password_str` AS `login_password_str`,
       `ravebizv4`.`contacts`.`role_enm` AS `role_enm`,
       `ravebizv4`.`contacts`.`title_str` AS `title_str`,
       `ravebizv4`.`contacts`.`street_address_str` AS `street_address_str`,
       `ravebizv4`.`contacts`.`office_phone_str` AS `office_phone_str`,
       `ravebizv4`.`contacts`.`office_phone_ext_str` AS `office_phone_ext_str`,
       `ravebizv4`.`contacts`.`fax_str` AS `fax_str`,
       `ravebizv4`.`contacts`.`mobile_phone_str` AS `mobile_phone_str`,
       `ravebizv4`.`contacts`.`home_phone_str` AS `home_phone_str`,
       `ravebizv4`.`contacts`.`skype_id_str` AS `skype_id_str`,
       `ravebizv4`.`contacts`.`notes_str` AS `notes_str` 
from (`ravebizv4`.`contacts` join `ravebizv4`.`zip`)</td></tr>
</table>
</td>
</tr>
</table>
</body>
</html>
